<?php
$db   = Zend_Registry::get(REGISTRY_KEY_DBO);
// detect language to find language store in database
$lang = "_".Zendvn_System_Info::getLanguageDetail(0);

$sql = $db ->select()
->from(TBL_PRF."cvproject as p",array("cvp_name","cvp_detail".$lang,"cvp_image","cvp_link"))
->joinLeft(TBL_PRF.'cvprojecttype AS t','t.cvpt_id = p.cvp_type_id',array('t.cvpt_name'.$lang.' as cvp_type','t.cvpt_id as cvp_typeid'));
$this->gcTransport->data = $db->fetchAll($sql);

$sql2 = $db ->select()
->from(TBL_PRF."cvprojecttype as p",array("cvpt_id","cvpt_name".$lang));

$this->gcTransport->data2 = $db->fetchAll($sql2);
$this->gcTransport->data = $db->fetchAll($sql);


$this->gcTransport->lang = $lang;
$this->gcLoadView();
